import json
import xlrd

if __name__ == '__main__':
    book = xlrd.open_workbook('/Users/h/Downloads/国家列表.xls')
    sheet = book.sheet_by_name('Sheet1')
    keyarray = {}
    startrow = 1
    for i in range(startrow, sheet.nrows):
        row = sheet.row(i)
        key = row[0].value
        value = row[1].value
        keyarray[key] = value

    print(json.dumps(keyarray))
